Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLGetInfo

This section shows information the ODBC Driver returns to SQLGetInfo.

Table 64 describes return values to SQLGetInfo from the ODBC driver.

Table 64: Information the ODBC driver returns to SQLGetInfo

Description	fInfoType argument	Returns
Guaranteed execute privileges on all procedures returned by SQLProcedures.	SQL_ACCESSIBLE _PROCEDURES	N
Guaranteed read access to all table names returned by SQLTables.	SQL_ACCESSIBLE_TABLES	N
Maximum number of active connections.	SQL_ACTIVE_ CONNECTIONS	0
Maximum number of active statements supported for an active connection.	SQL_ACTIVE_STATEMENTS	0
Maximum number of active environments.	SQL_ACTIVE_ ENVIRONMENTS	0
Support for ALTER DOMAIN statement.	SQL_ALTER_DOMAIN	0x00000000
Support for ALTER TABLE clauses.	SQL_ALTER_TABLE	0x00000000
SQL Conformance.	SQL_SQL_CONFORMANCE	SQL_SC_SQL92_ENTRY
Support for datetime literals.	SQL_DATETIME_LITERALS	0x00000000
Level of asynchronous mode support.	SQL_ASYNC_MODE	SQL_AM_NONE
Behavior with respect to the availability of row counts in batches.	SQL_BATCH_ROW_COUNT	0x00000000
Support for batches.	SQL_BATCH_SUPPORT	0x00000000
Support for bookmarks.	SQL_BOOKMARK_ PERSISTENCE	SQL_BP_UPDATE SQL_BP_SCROLL
Position of qualifier in a qualified table name.	SQL_CATALOG_LOCATION	0 (Does not support)
Support for catalog names.	SQL_CATALOG_NAME	N
Character used to separate table, column qualifiers.	SQL_CATALOG_NAME_ SEPARATOR	“ ”
Term for object that qualifies table names.	SQL_CATALOG_TERM	“ ”
Statements that support qualifiers.	SQL_CATALOG_USAGE	0x00000000
Default collation sequence name for the default character set.	SQL_COLLATION_SEQ	“ ”
Support for column aliases.	SQL_COLUMN_ALIAS	Y
Result of concatenation of NULL character column with non-NULL column.	SQL_CONCAT_NULL_ BEHAVIOR	SQL_CB_NULL = 0
Conversion from BIGINT.	SQL_CONVERT_BIGINT	SQL_CVT_CHAR SQL_CVT_BIGINT SQL_CVT_TINYINT SQL_CVT_SMALLINT SQL_CVT_INTEGER SQL_CVT_FLOAT SQL_CVT_DOUBLE
Conversion from BINARY.	SQL_CONVERT_BINARY	0x00000000
Conversion from BIT.	SQL_CONVERT_BIT	0x00000000
Conversion from CHAR.	SQL_CONVERT_CHAR	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT SQL_CVT_DATE SQL_CVT_TIME SQL_CVT_TIMESTAMP
Conversion from DATE.	SQL_CONVERT_DATE	SQL_CVT_CHAR SQL_CVT_VARCHAR SQL_CVT_DATE SQL_CVT_TIMESTAMP
Conversion from DECIMAL.	SQL_CONVERT_DECIMAL	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from DOUBLE.	SQL_CONVERT_DOUBLE	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from FLOAT.	SQL_CONVERT_FLOAT	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Support for conversion functions.	SQL_CONVERT_FUNCTIONS	SQL_FN_CVT_CONVERT
Conversion from INTEGER.	SQL_CONVERT_INTEGER	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from INTERVAL_DAY_TIME.	SQL_CONVERT_INTERVAL_ DAY_TIME	0x00000000
Conversion from INTERVAL_YEAR_MONTH.	SQL_CONVERT_INTERVAL_ YEAR_MONTH	0x00000000
Conversion from LONGVARBINARY.	SQL_CONVERT _LONGVARBINARY	0x00000000
Conversion from LONGVARCHAR.	SQL_CONVERT_ LONGVARCHAR	0x00000000
Conversion from NUMERIC.	SQL_CONVERT_NUMERIC	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from REAL.	SQL_CONVERT_REAL	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from SMALLINT.	SQL_CONVERT_SMALLINT	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from TIME.	SQL_CONVERT_TIME	SQL_CVT_CHAR SQL_CVT_TIME SQL_CVT_TIMESTAMP
Conversion from TIMESTAMP.	SQL_CONVERT_TIMESTAMP	SQL_CVT_CHAR SQL_CVT_VARCHAR SQL_CVT_DATE SQL_CVT_TIME SQL_CVT_TIMESTAMP
Conversion from TINYINT.	SQL_CONVERT_TINYINT	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT
Conversion from VARBINARY.	SQL_CONVERT_ VARBINARY	0x00000000
Conversion from VARCHAR.	SQL_CONVERT_VARCHAR	SQL_CVT_CHAR SQL_CVT_NUMERIC SQL_CVT_DECIMAL SQL_CVT_INTEGER SQL_CVT_SMALLINT SQL_CVT_FLOAT SQL_CVT_REAL SQL_CVT_DOUBLE SQL_CVT_VARCHAR SQL_CVT_TINYINT SQL_CVT_BIGINT SQL_CVT_DATE SQL_CVT_TIME SQL_CVT_TIMESTAMP
Conversion from WCHAR.	SQL_CONVERT_WCHAR	0x00000000
Conversion from WLONGVARCHAR.	SQL_CONVERT_ WLONGVARCHAR	0x00000000
Conversion from WVARCHAR.	SQL_CONVERT_WVARCHAR	0x00000000
Support for table correlation names.	SQL_CORRELATION_NAME	SQL_CN_DIFFERENT
Support for CREATE ASSERTION statement.	SQL_CREATE_ASSERTION	0x00000000
Support for CREATE CHARACTER SET statement.	SQL_CREATE_ CHARACTER SET	0x00000000
Support for CREATE COLLATION statement.	SQL_CREATE_COLLATION	0x00000000
Support for CREATE DOMAIN statement.	SQL_CREATE_DOMAIN	0x00000000
Support for CREATE SCHEMA statement.	SQL_CREATE_SCHEMA	0x00000000
Support for CREATE TABLE statement.	SQL_CREATE_TABLE	SQL_CT_CREATE_ TABLE SQL_CT_COLUMN _CONSTRAINT SQL_CT_TABLE _CONSTRAINT
Support for CREATE TRANSLATION statement.	SQL_CREATE_ TRANSLATION	0x00000000
Support for CREATE VIEW statement.	SQL_CREATE_VIEW	SQL_CV_CREATE_VIEW SQL_CV_CHECK_OPTION
Effect of COMMIT operation on cursors and prepared statements.	SQL_CURSOR_COMMIT_ BEHAVIOR	SQL_CB_PRESERVE
Effect of ROLLBACK operation on cursors and prepared statements.	SQL_CURSOR_ROLLBACK _BEHAVIOR	0x00000000
Support for cursor sensitivity.	SQL_CURSOR_SENSITIVITY	SQL_INSENSITIVE
Name of the data source as specified to the ODBC Administrator.	SQL_DATA_SOURCE_NAME	(String containing the name)
Access limited to read-only.	SQL_DATA_SOURCE_READ_ ONLY	N (Read-write access)
Name of the Progress SQL-92 ODBC data source on the server system.	SQL_DATABASE_NAME	(String containing the name)
Name of the database product supporting the data source.	SQL_DBMS_NAME	OPENEDGE
Version of the database product.	SQL_DBMS_VER	10.0A1B
Default transaction isolation level.	SQL_DEFAULT_TXN_ ISOLATION	SQL_TXN_REPEATABLE_ READ
Support for describing parameters via DESCRIBE INPUT statement.	SQL_DESCRIBE_ PARAMETER	Y (Supports)
Version of the driver manager.	SQL_DM_VER	03.52.9001.0000 WIN 03.00.2301.0000 UNIX
Connection handle determined by the argument InfoType.	SQL_DRIVER_HDBC	0x0013EBE0
Driver’s descriptor handle determined by the Driver Manager’s descriptor handle.	SQL_DRIVER_HDESC	0x0013F820
Environment handle determined by the argument InfoType.	SQL_DRIVER_HENV	0x0013C8A0
Handle library from the load library returned to the Driver Manager when it loaded the driver DLL.	SQL_DRIVER_HLIB	0x28660000
Driver’s statement handle determined by the Driver Manager’s statement handle.	SQL_DRIVER_HSTMT	0x001427E0
Name of the dynamic link library file for the ODBC Driver.	SQL_DRIVER_NAME	Windows PGPRO918.DLL AIX, SOLARIS, LINUX PGPRO918.SO HPIIX PGPRO918.SL
Supported ODBC version.	SQL_DRIVER_ODBC_VER	03.52
Current version of the ODBC Driver.	SQL_DRIVER_VER	04.10.0000
Support for DROP ASSERTION statement.	SQL_DROP_ASSERTION	0x00000000
Support for DROP CHARACTER SET statement.	SQL_DROP_CHARACTER_ SET	0x00000000
Support for DROP COLLATION statement.	SQL_DROP_COLLATION	0x00000000
Support for DROP DOMAIN statement.	SQL_DROP_DOMAIN	0x00000000
Support for DROP SCHEMA statement.	SQL_DROP_SCHEMA	0x00000000
Support for DROP TABLE statement.	SQL_DROP_TABLE	SQL_DT_DROP_TABLE
Support for DROP TRANSLATION statement.	SQL_DROP_TRANSLATION	0x00000000
Support for DROP VIEW statement.	SQL_DROP_VIEW	SQL_DT_DROP_VIEW
Supported attributes of a dynamic cursor: subset 1.	SQL_DYNAMIC_CURSOR_ ATTRIBUTES1	0x00000000
Supported attributes of a dynamic cursor: subset 2.	SQL_DYNAMIC_CURSOR_ ATTRIBUTES2	0x00000000
Support for expressions in ORDER BY clause.	SQL_EXPRESSIONS_IN_ ORDERBY	Y
Supported fetch direction options.	SQL_FETCH_DIRECTION	SQL_FD_FETCH_NEXT SQL_FD_FETCH_FIRST SQL_FD_FETCH_LAST SQL_FD_FETCH_PRIOR SQL_FD_FETCH_ ABSOLUTE SQL_FD_FETCH_ RELATIVE SQL_FD_FETCH_ BOOKMARK
Single-tier driver behavior.	SQL_FILE_USAGE	SQL_FILE_NOT _SUPPORTED
Supported attributes of a forward-only cursor: subset 1.	SQL_FORWARD_ONLY_ CURSOR_ATTRIBUTES1	SQL_CA1_NEXT SQL_CA1_BULK_ADD
Supported attributes of a forward-only cursor: subset 2.	SQL_FORWARD_ONLY_ CURSOR_ATTRIBUTES2	SQL_CA2_MAX_ROWS_ SELECT SQL_CA2_MAX_ROWS_ CATALOG
Supported extensions to SQLGetData.	SQL_GETDATA_ EXTENSIONS	SQL_GD_ANY_COLUMN SQL_GD_ANY_ORDER SQL_GD_BOUND
Relationship between GROUP BY clause and columns in the select list.	SQL_GROUP_BY	SQL_GB_GROUP_BY _CONTAINS_SELECT
Case sensitivity of user-supplied names.	SQL_IDENTIFIER_CASE	SQL_IC_UPPER
Character used to enclose delimited identifiers.	SQL_IDENTIFIER_QUOTE_ CHAR	" (Double quotation mark)
Keywords supported in the CREATE INDEX statement.	SQL_INDEX_KEYWORDS	SQL_IK_ASC | SQL_IK_DESC
Supported views in INFORMATION_SCHEMA.	SQL_INFO_SCHEMA_VIEWS	0x00000000
Support for Integrity Enhancement Facility.	SQL_INTEGRITY	Y
Supported attributes of a keyset cursor: subset 1.	SQL_KEYSET_CURSOR_ ATTRIBUTES1	SQL_CA1_NEXT SQL_CA1_ABSOLUTE SQL_CA1_RELATIVE SQL_CA1_BOOKMAR K SQL_CA1_LOCK_NO_ CHANGE SQL_CA1_POS_POSITION SQL_CA1_POS_UPDATE SQL_CA1_POS_DELETE SQL_CA1_POS_REFRESH SQL_CA1_POSITIONED _UPDATE SQL_CA1_POSITIONED _DELETE SQL_CA1_SELECT_FOR _UPDATE SQL_CA1_BULK_ADD
Supported attributes of a keyset cursor: subset 2.	SQL_KEYSET_CURSOR_ ATTRIBUTES2	SQL_CA2_READ_ONLY_ CONCURRENCY SQL_CA2_OPT_VALUES _CONCURRENCY SQL_CA2_SENSITIVITY _DELETIONS SQL_CA2_SENSITIVITY _UPDATES SQL_CA2_MAX_ROWS _SELECT SQL_CA2_CRC_EXACT SQL_CA2_SIMULATE _TRY_UNIQUE
Data source specific keywords.	SQL_KEYWORDS	See the OpenEdge SQL Reserved Words section for a list of SQL Keywords.
Support for escape clause in LIKE predicates.	SQL_LIKE_ESCAPE_CLAUSE	Y
Support for lock types.	SQL_LOCK_TYPES	SQL_LCK_NO_CHANGE
Maximum number of active concurrent statements in asynchronous mode.	SQL_MAX_ASYNC _CONCURRENT_ STATEMENTS	0
Maximum length in hexadecimal characters of binary literals.	SQL_MAX_BINARY_ LITERAL_LEN	31,995
Maximum length of a table or column qualifier.	SQL_MAX_CATALOG_NAME _LEN	0
Maximum length in characters of character string literals.	SQL_MAX_CHAR_LITERAL_LEN	31,995
Maximum length of a column name.	SQL_MAX_COLUMN_NAME _LEN	32
Maximum number of columns allowed in GROUP BY clause.	SQL_MAX_COLUMNS_IN _GROUP_BY	499
Maximum number of columns allowed in an index.	SQL_MAX_COLUMNS_IN _INDEX	16
Maximum number of columns allowed in ORDER BY clause.	SQL_MAX_COLUMNS_IN _ORDER_BY	0
Maximum number of columns allowed in a select list.	SQL_MAX_COLUMNS_IN _SELECT	500
Maximum number of columns allowed in a table.	SQL_MAX_COLUMNS_IN _TABLE	500
Maximum number of active SQL statements.	SQL_MAX_CONCURRENT _ACTIVITIES	0 (No maximum)
Maximum length of a cursor name.	SQL_MAX_CURSOR_NAME _LEN	18
Maximum number of active connections.	SQL_MAX_DRIVER _CONNECTIONS	0
Maximum length of user-defined names.	SQL_MAX_IDENTIFIER_LEN	32
Maximum number of bytes allowed in the combined fields of an index.	SQL_MAX_INDEX_SIZE	115
Maximum length of a procedure name.	SQL_MAX_PROCEDURE_ NAME_LEN	32
Maximum length in bytes of a table row.	SQL_MAX_ROW_SIZE	0
Whether maximum row size includes LONGVARCHAR and LONGVARBINARY.	SQL_MAX_ROW_SIZE _INCLUDES_LONG	N
Maximum length of an owner name.	SQL_MAX_SCHEMA_NAME _LEN	32
Maximum number of characters in an SQL statement.	SQL_MAX_STATEMENT_ LEN	131,000
Maximum length of a table name.	SQL_MAX_TABLE_NAME_ LEN	32
Maximum number of tables allowed in FROM clause.	SQL_MAX_TABLES_IN_ SELECT	250
Maximum length of a user name.	SQL_MAX_USER_NAME_ LEN	32
Maximum length of owner name.	SQL_MAX_OWNER_NAME_ LEN	32
Maximum length of a qualifier name.	SQL_MAX_QUALIFIER_ NAME_LEN	0
Support for multiple result sets.	SQL_MULT_RESULT_SETS	N
Support for active transactions on multiple connections.	SQL_MULTIPLE_ACTIVE _TXN	Y
Whether data source requires length of LONGVARCHAR and LONGVARBINARY data.	SQL_NEED_LONG_DATA _LEN	Y
Support for NOT NULL clause in CREATE TABLE statement.	SQL_NON_NULLABLE _COLUMNS	SQL_NNC_NON_NULL
Where null values are sorted in a list.	SQL_NULL_COLLATION	SQL_NC_LOW
Numeric functions supported.	SQL_NUMERIC_FUNCTIONS	SQL_FN_NUM_ABS SQL_FN_NUM_ACOS SQL_FN_NUM_ASIN SQL_FN_NUM_ATAN SQL_FN_NUM_ATAN2 SQL_FN_NUM_CEILING SQL_FN_NUM_COS SQL_FN_NUM_EXP SQL_FN_NUM_FLOOR SQL_FN_NUM_MOD SQL_FN_NUM_PI SQL_FN_NUM_POWER SQL_FN_NUM_RADIANS SQL_FN_NUM_RAND SQL_FN_NUM_ROUND SQL_FN_NUM_SIGN SQL_FN_NUM_SIN SQL_FN_NUM_SQRT SQL_FN_NUM_TAN SQL_FN_NUM_DEGREES SQL_FN_NUM_LOG10
Level of ODBC conformance.	SQL_ODBC_API _CONFORMANCE	SQL_OAC_LEVEL1
Level of ODBC 3.x interface conformance.	SQL_ODBC_INTERFACE _CONFORMANCE	SQL_OIC_CORE
SQL Access Group (SAG) conformance.	SQL_ODBC_SAG_CLI _CONFORMANCE	SQL_OSCC_COMPLIANT
Level of SQL conformance.	SQL_ODBC_SQL _CONFORMANCE	SQL_OSC_EXTENDED
Referential integrity syntax support.	SQL_ODBC_SQL_OPT_IEF	Y
ODBC version supported by driver manager.	SQL_ODBC_VER	03.51.0000
Types of outer joins supported.	SQL_OJ_CAPABILITIES	SQL_OJ_LEFT SQL_OJ_RIGHT SQL_OJ_NOT_ORDERED SQL_OJ_INNER SQL_OJ_ALL _COMPARISON_OPS
Whether columns in ORDER BY clause must also be in select list.	SQL_ORDER_BY_COLUMNS _IN_SELECT	N
Support for outer joins.	SQL_OUTER_JOINS	Y
Name for an owner.	SQL_OWNER_TERM	owner
Statements in which owner can be used.	SQL_OWNER_USAGE	SQL_OU_DML _STATEMENTS SQL_OU_PROCEDURE _INVOCATION SQL_OU_TABLE _DEFINITION SQL_OU_INDEX _DEFINITION SQL_OU_PRIVILEGE _DEFINITION
Characteristics of row counts available in a parameterized execution.	SQL_PARAM_ARRAY_ROW _COUNTS	SQL_PARC_NO_BATCH
Characteristics of result sets available in a parameterized execution.	SQL_PARAM_ARRAY_ SELECTS	SQL_PAS_NO_SELECT
Supported operations in SQLSetPos.	SQL_POS_OPERATIONS	SQL_POS_POSITION SQL_POS_REFRESH SQL_POS_UPDATE SQL_POS_DELETE SQL_POS_ADD
Supported positioned SQL statements.	SQL_POSITIONED_ STATEMENTS	SQL_PS_POSITIONED _DELETE SQL_PS_POSITIONED _UPDATE SQL_PS_SELECT_FOR _UPDATE
Term for procedures.	SQL_PROCEDURE_TERM	procedure
SQL procedures support.	SQL_PROCEDURES	Y
Support for qualifiers.	SQL_QUALIFIER_USAGE	0x00000000
Case sensitivity of quoted user-supplied names.	SQL_QUOTED_IDENTIFIER _CASE	SQL_IC_MIXED
Separator character used between qualifier name and element.	SQL_QUALIFIER_NAME _SEPARATOR	“ ”
Term used for a qualifier.	SQL_QUALIFIER_TERM	“ ”
Position of the qualifier in a qualified table name.	SQL_QUALIFIER_LOCATION	0 (Does not support)
Detect changes to any row in mixed-cursor operations.	SQL_ROW_UPDATES	Y
Term for entity that has owner privileges on objects.	SQL_SCHEMA_TERM	owner
Statements that support use of owner qualifiers.	SQL_SCHEMA_USAGE	SQL_OU_DML_ STATEMENTS SQL_OU_PROCEDURE _INVOCATION SQL_OU_TABLE _DEFINITION SQL_OU_INDEX _DEFINITION SQL_OU_PRIVILEGE _DEFINITION
Options supported for scrollable cursors.	SQL_SCROLL_OPTIONS	SQL_SO_FORWARD _ONLY SQL_SO_STATIC SQL_SO_KEYSET_DRIVEN
Support for scrollable cursors.	SQL_SCROLL_ CONCURRENCY	SQL_SCCO_READ_ONLY SQL_SCCO_OPT_VALUES
Character to permit wildcard characters in search strings.	SQL_SEARCH_PATTERN _ESCAPE	\ (Backslash)
Name of the system where the ODBC data source resides.	SQL_SERVER_NAME	(String containing the name)
Special characters allowed in user-supplied names.	SQL_SPECIAL_ CHARACTERS	“_”, “%”
Datetime scalar functions supported.	SQL_SQL92_DATETIME _FUNCTIONS	0x00000000
Behavior of DELETE statement that refers to a foreign key.	SQL_SQL92_FOREIGN_KEY _DELETE_RULE	0x00000000
Behavior of UPDATE statement that refers to a foreign key.	SQL_SQL92_FOREIGN_KEY _UPDATE_RULE	0x00000000
GRANT statement clauses supported.	SQL_SQL92_GRANT	SQL_SG_DELETE_TABLE SQL_SG_INSERT_TABLE SQL_SG_INSERT _COLUMN SQL_SG_REFERENCES _TABLE SQL_SG_REFERENCES _COLUMN SQL_SG_SELECT_TABLE SQL_SG_UPDATE _TABLE SQL_SG_UPDATE _COLUMN
Numeric scalar functions supported.	SQL_SQL92_NUMERIC_ VALUE_FUNCTIONS	SQL_SNVF_CHAR _LENGTH SQL_SNVF_CHARACTER _LENGTH
Predicates supported.	SQL_SQL92_PREDICATES	SP_EXISTS SQL_SP_ISNOTNULL SQL_SP_ISNULL SQL_SP_UNIQUE SQL_SP_LIKE SQL_SP_IN SQL_SP_BETWEEN
Relational join operators supported.	SQL_SQL92_RELATIONAL _JOIN_OPERATORS	0x00000000
REVOKE statement clauses supported.	SQL_SQL92_REVOKE	SQL_SR_GRANT_ OPTION_FOR SQL_SR_CASCADE SQL_SR_DELETE_TABLE SQL_SR_INSERT_TABLE SQL_SR_INSERT _COLUMN SQL_SR_REFERENCES _TABLE SQL_SR_REFERENCES _COLUMN SQL_SR_SELECT_TABLE SQL_SR_UPDATE _TABLE SQL_SR_UPDATE _COLUMN
Row value constructor expressions supported.	SQL_SQL92_ROW_VALUE _CONSTRUCTOR	0x00000000
String scalar functions supported.	SQL_SQL92_STRING _FUNCTIONS	SQL_SSF_CONVERT SQL_SSF_LOWER SQL_SSF_UPPER SQL_SSF_SUBSTRING SQL_SSF_TRANSLATE SQL_SSF_TRIM _LEADING SQL_SSF_TRIM_TRAILING
Value expressions supported.	SQL_SQL92_VALUE _EXPRESSIONS	SQL_SVE_COALESCE SQL_SVE_NULLIF
CLI standards to which the driver conforms.	SQL_STANDARD_CLI _CONFORMANCE	SQL_SCC_XOPEN_CLI _VERSION1
Supported attributes of a static cursor: subset 1.	SQL_STATIC_CURSOR _ATTRIBUTES1	SQL_CA1_NEXT SQL_CA1_ABSOLUTE SQL_CA1_RELATIVE SQL_CA1_BOOKMARK SQL_CA1_LOCK_NO _CHANGE SQL_CA1_POS_POSITION SQL_CA1_POS_UPDATE SQL_CA1_POS_DELETE SQL_CA1_POS_REFRESH SQL_CA1_POSITIONED _UPDATE SQL_CA1_POSITIONED _DELETE SQL_CA1_SELECT_FOR _UPDATE SQL_CA1_BULK_ADD
Supported attributes of a static cursor: subset 2.	SQL_STATIC_CURSOR _ATTRIBUTES2	SQL_CA2_READ_ONLY _CONCURRENCY SQL_CA2_OPT_VALUES _CONCURRENCY SQL_CA2_CRC_EXACT SQL_CA2_SIMULATE _TRY_UNIQUE
Support for detection of changes made to a static or key-set driven cursor through SQLSetPos.	SQL_STATIC_SENSITIVITY	0x00000000
String functions supported.	SQL_STRING_FUNCTIONS	SQL_FN_STR_CONCAT SQL_FN_STR_INSERT SQL_FN_STR_LEFT SQL_FN_STR_LTRIM SQL_FN_STR_LENGTH SQL_FN_STR_LOCATE SQL_FN_STR_LCASE SQL_FN_STR_REPEAT SQL_FN_STR_REPLACE SQL_FN_STR_RIGHT SQL_FN_STR_RTRIM SQL_FN_STR _SUBSTRING SQL_FN_STR_UCASE SQL_FN_STR_ASCII SQL_FN_STR_CHAR SQL_FN_STR _DIFFERENCE SQL_FN_STR_LOCATE_2 SQL_FN_STR_SPACE SQL_FN_STR_CHAR _LENGTH SQL_FN_STR _CHARACTER_LENGTH
Predicates that support subqueries.	SQL_SUBQUERIES	SQL_SQ_COMPARISON SQL_SQ_EXISTS SQL_SQ_IN SQL_SQ_QUANTIFIED
System functions supported.	SQL_SYSTEM_FUNCTIONS	SQL_FN_SYS _USERNAME
Term for tables.	SQL_TABLE_TERM	table
Timestamp intervals supported for TIMESTAMPADD function.	SQL_TIMEDATE_ADD _INTERVALS	0x00000000
Timestamp intervals supported for TIMESTAMPDIFF function.	SQL_TIMEDATE_DIFF _INTERVALS	0x00000000
Date-time functions supported.	SQL_TIMEDATE_ FUNCTIONS	SQL_FN_TD_NOW SQL_FN_CURDATE SQL_FN_TD _DAYOFMONTH SQL_FN_TD _DAYOFWEEK SQL_FN_TD _DAYOFYEAR SQL_FN_TD_MONTH SQL_FN_TD_QUARTER SQL_FN_TD_WEEK SQL_FN_TD_YEAR SQL_FN_CURTIME SQL_FN_TD_HOUR SQL_FN_TD_MINUTE SQL_FN_TD_SECOND SQL_FN_TD _TIMESTAMP_ADD SQL_FN_TD _TIMESTAMPDIFF SQL_FN_TD_DAYNAME SQL_FN_TD _MONTHNAME
Support for DML, DDL within transactions.	SQL_TXN_CAPABLE	SQL_TC_ALL
Options for setting transaction isolation levels.	SQL_TXN_ISOLATION_ OPTION	SQL_TXN_READ _UNCOMMITTED SQL_TXN _SERIALIZABLE SQL_TXN_READ _COMMITTED SQL_TXN_REPEATABLE _READ
UNION support.	SQL_UNION	SQL_U_UNION SQL_U_UNION_ALL
Name of user connected to the data source.	SQL_USER_NAME	(String containing the name)
Year of publication of the X/Open specification with which the driver complies.	SQL_XOPEN_CLI_YEAR	1995